﻿CREATE TABLE [ccc].[Pledge] (
    [Id]                INT           IDENTITY (1, 1) NOT NULL,
    [UserId]            INT           NOT NULL,
    [PledgeId]          INT           NOT NULL,
    [EmailAddress]      VARCHAR (100) NOT NULL,
    [FirstName]         VARCHAR (50)  NOT NULL,
    [LastName]          VARCHAR (50)  NOT NULL,
    [AuthenticationKey] VARCHAR (10)  NOT NULL,
    [Authenticated]     BIT           NOT NULL,
    [Created]           DATETIME      NOT NULL,
    [ConcurrencyId]     TIMESTAMP     NOT NULL
);

